﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SellingSoln.aspx.cs" Inherits="SellingSoln" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style1
        {
        }
        .style2
        {
            width: 170px;
        }
        .style3
        {
            width: 84px;
        }
        .style5
        {
            width: 103px;
        }
        .style6
        {
        }
        .style7
        {
            width: 196px;
        }
        .style8
        {
            text-align: left;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <p>
        <br />
        <table style="width: 100%; border: 1px solid #000">
            <tr>
                <td style="border: 1px solid #000; text-align: left;">
                    Solutions :</td>
                <td class="style8" style="border: 1px solid #000">
                    Accessories :</td>
            </tr>
            <tr>
                <td style="border: 1px solid #000">
                    <asp:GridView ID="GridView1" runat="server">
                    </asp:GridView>
                </td>
                <td style="border: 1px solid #000">
                    <asp:GridView ID="GridView2" runat="server">
                    </asp:GridView>
                </td>
            </tr>
        </table>
        <br />
        <table style="width:100%;">
            <tr>
                <td class="style1" style="text-align: left">
                    Employee :</td>
                <td class="style2" style="text-align: left">
                    <asp:DropDownList ID="DropDownList1" runat="server" 
                        DataSourceID="SqlDataSource1" DataTextField="name" DataValueField="name" 
                        Width="150px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT [name] FROM [employee] WHERE ([job] = @job) ORDER BY [name]">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="Reception" Name="job" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style3" style="text-align: left">
                    Client :</td>
                <td class="style5" style="text-align: left">
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                </td>
                <td class="style5" style="text-align: left">
                    Date :</td>
                <td class="style5" style="text-align: left">
                    <asp:Label ID="Label2" runat="server"></asp:Label>
                </td>
                <td class="style6" style="text-align: left">
                    &nbsp;</td>
                <td class="style7" style="text-align: left">
                    &nbsp;</td>
                <td style="text-align: left">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1" style="text-align: left">
                    Solutions :</td>
                <td class="style2" style="text-align: left">
                    &nbsp;</td>
                <td class="style3" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style6" style="text-align: left">
                    Accessories :</td>
                <td class="style7" style="text-align: left">
                    &nbsp;</td>
                <td style="text-align: left">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1" style="text-align: left">
                                Brand Name :</td>
                <td class="style2" style="text-align: left">
                    <asp:DropDownList ID="DropDownList2" runat="server" 
                        DataSourceID="SqlDataSource2" DataTextField="name" DataValueField="name" 
                        Height="22px" Width="150px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT [name] FROM [brandsoln] ORDER BY [name]">
                    </asp:SqlDataSource>
                </td>
                <td class="style3" style="text-align: left">
                    Bottle size :</td>
                <td class="style5" style="text-align: left">
                                <asp:DropDownList ID="DropDownList19" runat="server" Height="22px" Width="78px">
                                    <asp:ListItem>30</asp:ListItem>
                                    <asp:ListItem>50</asp:ListItem>
                                    <asp:ListItem>60</asp:ListItem>
                                    <asp:ListItem>100</asp:ListItem>
                                    <asp:ListItem>120</asp:ListItem>
                                    <asp:ListItem>240</asp:ListItem>
                                    <asp:ListItem>250</asp:ListItem>
                                    <asp:ListItem>340</asp:ListItem>
                                </asp:DropDownList>
                            </td>
                <td class="style5" style="text-align: left">
                    <asp:Button ID="Button4" runat="server" Height="29px" onclick="Button4_Click" 
                        Text="Show" Width="64px" />
                </td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style6" style="text-align: left">
                    Brand Name :</td>
                <td class="style7" style="text-align: left">
                    <asp:DropDownList ID="DropDownList3" runat="server" 
                        DataSourceID="SqlDataSource3" DataTextField="name" DataValueField="name" 
                        Height="22px" Width="150px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT [name] FROM [nameaccs] ORDER BY [name]">
                    </asp:SqlDataSource>
                </td>
                <td style="text-align: left">
                    <asp:Button ID="Button5" runat="server" Height="29px" onclick="Button5_Click" 
                        Text="Show" Width="64px" />
                </td>
            </tr>
            <tr>
                <td class="style1" style="text-align: left">
                    Cost :</td>
                <td class="style2" style="text-align: left">
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </td>
                <td class="style3" style="text-align: left">
                    <asp:Button ID="Button1" runat="server" Height="29px" onclick="Button1_Click" 
                        Text="Add" Width="64px" />
                </td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style6" style="text-align: left">
                    Cost :</td>
                <td class="style7" style="text-align: left">
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                </td>
                <td style="text-align: left">
                    <asp:Button ID="Button2" runat="server" Height="29px" onclick="Button2_Click" 
                        Text="Add" Width="64px" />
                </td>
            </tr>
            <tr>
                <td class="style1" colspan="5" style="text-align: left">
                    <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource4" DataKeyNames="id">
                        <Columns>
                            <asp:CommandField ShowDeleteButton="True" />
                            <asp:BoundField DataField="employee" HeaderText="employee" 
                                SortExpression="employee" />
                            <asp:BoundField DataField="datee" HeaderText="datee" 
                                SortExpression="datee" />
                            <asp:BoundField DataField="client" HeaderText="client" 
                                SortExpression="client" />
                            <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                SortExpression="brandname" />
                            <asp:BoundField DataField="bottlesize" HeaderText="bottlesize" 
                                SortExpression="bottlesize" />
                            <asp:BoundField DataField="cost" HeaderText="cost" SortExpression="cost" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT * FROM [fcsoln]" 
                        DeleteCommand="DELETE FROM [fcsoln] WHERE [id] = @id" 
                        InsertCommand="INSERT INTO [fcsoln] ([employee], [datee], [client], [brandname], [bottlesize], [cost]) VALUES (@employee, @datee, @client, @brandname, @bottlesize, @cost)" 
                        UpdateCommand="UPDATE [fcsoln] SET [employee] = @employee, [datee] = @datee, [client] = @client, [brandname] = @brandname, [bottlesize] = @bottlesize, [cost] = @cost WHERE [id] = @id">
                        <DeleteParameters>
                            <asp:Parameter Name="id" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="employee" Type="String" />
                            <asp:Parameter DbType="Date" Name="datee" />
                            <asp:Parameter Name="client" Type="Int32" />
                            <asp:Parameter Name="brandname" Type="String" />
                            <asp:Parameter Name="bottlesize" Type="Int32" />
                            <asp:Parameter Name="cost" Type="Int32" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="employee" Type="String" />
                            <asp:Parameter DbType="Date" Name="datee" />
                            <asp:Parameter Name="client" Type="Int32" />
                            <asp:Parameter Name="brandname" Type="String" />
                            <asp:Parameter Name="bottlesize" Type="Int32" />
                            <asp:Parameter Name="cost" Type="Int32" />
                            <asp:Parameter Name="id" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style6" colspan="3" style="text-align: left">
                    <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
                        DataSourceID="SqlDataSource5" DataKeyNames="id">
                        <Columns>
                            <asp:CommandField ShowDeleteButton="True" />
                            <asp:BoundField DataField="employee" HeaderText="employee" 
                                SortExpression="employee" />
                            <asp:BoundField DataField="datee" HeaderText="datee" 
                                SortExpression="datee" />
                            <asp:BoundField DataField="client" HeaderText="client" 
                                SortExpression="client" />
                            <asp:BoundField DataField="brandname" HeaderText="brandname" 
                                SortExpression="brandname" />
                            <asp:BoundField DataField="cost" HeaderText="cost" SortExpression="cost" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT * FROM [fcaccs]" 
                        DeleteCommand="DELETE FROM [fcaccs] WHERE [id] = @id" 
                        InsertCommand="INSERT INTO [fcaccs] ([employee], [datee], [client], [brandname], [cost]) VALUES (@employee, @datee, @client, @brandname, @cost)" 
                        UpdateCommand="UPDATE [fcaccs] SET [employee] = @employee, [datee] = @datee, [client] = @client, [brandname] = @brandname, [cost] = @cost WHERE [id] = @id">
                        <DeleteParameters>
                            <asp:Parameter Name="id" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="employee" Type="String" />
                            <asp:Parameter DbType="Date" Name="datee" />
                            <asp:Parameter Name="client" Type="Int32" />
                            <asp:Parameter Name="brandname" Type="String" />
                            <asp:Parameter Name="cost" Type="Int32" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="employee" Type="String" />
                            <asp:Parameter DbType="Date" Name="datee" />
                            <asp:Parameter Name="client" Type="Int32" />
                            <asp:Parameter Name="brandname" Type="String" />
                            <asp:Parameter Name="cost" Type="Int32" />
                            <asp:Parameter Name="id" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td class="style1" colspan="4" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    &nbsp;</td>
                <td class="style5" style="text-align: left">
                    <asp:Button ID="Button3" runat="server" Height="40px" onclick="Button3_Click" 
                        Text="Insert" Width="85px" />
                </td>
                <td class="style6" colspan="3" style="text-align: left">
                    &nbsp;</td>
            </tr>
        </table>
    </p>
</asp:Content>

